<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "https://raw.githubusercontent.com/rbatis/rbatis/master/rbatis-codegen/mybatis-3-mapper.dtd">
<mapper>

  <delete id="del_role_menu_by_role_id">
    `delete from sys_role_menu`
    <where>
      `role_id in ( ${role_id} )`
    </where>
  </delete>

  <select id="get_menu_id_by_role_id">
    `select * from sys_role_menu`
    <where>
      `role_id = #{role_id}`
    </where>
  </select>

</mapper>